問１
CREATE TABLE item_category(category_id INT AUTO_INCREMENT PRIMARY KEY,category_name VARCHAR(256) NOT NULL);
INSERT INTO item_category(category_name)VALUES('家具')('飲料'),('食品');

問２
CREATE TABLE items(item_id INT PRIMARY KEY AUTO_INCREMENT,name VARCHAR(256) NOT NULL,price INT NOT NULL,category_id INT, FOREIGN KEY(category_id)REFERENCES item_category(category_id));
INSERT INTO items(name,price,category_id) VALUE('ローマのテーブル',150000,1),('げーたるーど2000 500ml',370,2),('原始肉',2500,3),('魅惑の椅子',100000,1);

問３
SELECT item_category.category_id,items.item_id,items.name,items.price,item_category.category_name FROM items INNER JOIN item_category ON items.category_id = item_category.category_id;

問４
SELECT item_category.category_id,items.item_id,items.name,items.price,item_category.category_name FROM items INNER JOIN item_category ON items.category_id = item_category.category_id ORDER BY price ASC;

問５
SELECT item_category.category_id,items.item_id,items.name,items.price,item_category.category_name FROM items INNER JOIN item_category ON items.category_id = item_category.category_id WHERE category_name='家具';

問６
SELECT item_category.category_id,items.item_id,items.name,items.price,item_category.category_name FROM items INNER JOIN item_category ON items.category_id = item_category.category_id WHERE price BETWEEN 1000 AND 50000;

問７
SELECT COUNT(*) AS data_count FROM items;

問８
SELECT item_category.category_id,items.item_id,items.name,items.price,item_category.category_name FROM items INNER JOIN item_category ON items.category_id = item_category.category_id WHERE price = (SELECT MAX(price) FROM items);

問９
SELECT item_category.category_id,items.item_id,items.name,items.price,item_category.category_name FROM items INNER JOIN item_category ON items.category_id = item_category.category_id WHERE name LIKE '%の%';

